/*
 Navicat Premium Data Transfer

 Source Server         : CBlog
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : CBlog

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 12/04/2023 22:06:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for about
-- ----------------------------
DROP TABLE IF EXISTS `about`;
CREATE TABLE `about` (
  `id` bigint NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_zh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of about
-- ----------------------------
BEGIN;
INSERT INTO `about` (`id`, `name_en`, `name_zh`, `value`) VALUES (1, 'title', '标题', '关于帅气的 CTS');
INSERT INTO `about` (`id`, `name_en`, `name_zh`, `value`) VALUES (2, 'musicId', '网易云歌曲ID', '423015580');
INSERT INTO `about` (`id`, `name_en`, `name_zh`, `value`) VALUES (3, 'content', '正文Markdown', '### 目前可以公开的情报\n\n* M E：已经是社畜了QAQ\n* 目标：做最酷的自己\n* 特征：兴趣至上\n* 爱好：写Bug、打游戏、看动漫\n* 性格：不喜约束、比较自私、偶尔emo\n\n### 我 & 博客\n\n生性只对感兴趣的事物充满热情，看到有趣的软件都会情不自禁地分析一波技术栈，可能用到了什么 algorithm，然后自我陶醉😅\n\n喜欢安静，但喜欢听得劲的电音，节奏控，coding 时喜欢听嗨歌，没事就跟着摇一摇🎵\n\n奶盖要摇匀了喝！🥛\n\n世界上只有甜的豆腐脑🤗\n\n[🍓NBlog个人博客系统](https://github.com/Naccl/NBlog)，本是学习过程中的产物，没想到能受到大家的喜爱，如果你也喜欢本博客，⭐️就是最好的鼓励\n\n博客现在托管在阿里云学生机，因为水管比较小，静态资源~~托管在 GitHub，通过 jsDelivr CDN减速~~已迁至又拍云🚀\n\n博客源码、部署相关疑难杂症请在 GitHub 提 issue，**请勿**在本博客留言\n\n如需联系我，请尽量使用 TG 或邮件，thanks（评论我也会收到提醒）\n\n');
INSERT INTO `about` (`id`, `name_en`, `name_zh`, `value`) VALUES (4, 'commentEnabled', '评论开关', 'true');
COMMIT;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
  `first_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章首图，用于随机文章展示',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章正文',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述',
  `is_published` bit(1) NOT NULL COMMENT '公开或私密',
  `is_recommend` bit(1) NOT NULL COMMENT '推荐开关',
  `is_appreciation` bit(1) NOT NULL COMMENT '赞赏开关',
  `is_comment_enabled` bit(1) NOT NULL COMMENT '评论开关',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `views` int NOT NULL COMMENT '浏览次数',
  `words` int NOT NULL COMMENT '文章字数',
  `read_time` int NOT NULL COMMENT '阅读时长(分钟)',
  `category_id` bigint NOT NULL COMMENT '文章分类',
  `is_top` bit(1) NOT NULL COMMENT '是否置顶',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码保护',
  `user_id` bigint DEFAULT NULL COMMENT '文章作者',
  `visible_model` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '可见性',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `type_id` (`category_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of blog
-- ----------------------------
BEGIN;
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (3, 'testBlogSace', 'http://helloblog', '这真的是一次测试', '这只是更新测试', b'1', b'1', b'1', b'0', '2022-12-12 00:00:00', '2023-04-04 17:05:17', 50, 500, 200, 1, b'1', '49549849', NULL, 'protect');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (4, '4444', 'http://helloblog', '这真的是一次测试', '这只是更新测试', b'0', b'1', b'1', b'0', '2022-12-12 00:00:00', '2023-02-23 15:32:02', 50, 500, 200, 1, b'1', '12312321321', NULL, 'protect');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (5, 'hello world5', '/home/aml', 'hello world5', '没啥', b'1', b'0', b'0', b'0', '2022-12-12 00:00:00', '2023-01-01 00:00:00', 50, 500, 100, 1, b'1', NULL, NULL, 'public');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (6, 'hello world6', '/home/aml', 'hello world6', '没啥', b'1', b'1', b'1', b'1', '2022-12-12 00:00:00', '2023-01-01 00:00:00', 50, 500, 100, 1, b'0', NULL, NULL, 'public');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (7, 'hello world7', '/home/aml', 'hello world7', '没啥', b'1', b'1', b'1', b'1', '2022-12-12 00:00:00', '2023-01-01 00:00:00', 50, 500, 100, 1, b'0', NULL, NULL, 'public');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (8, 'testBlogSace', 'http://helloblog', '这真的是一次测试', '这只是一次测试', b'0', b'0', b'0', b'0', '2023-02-23 13:29:38', '2023-02-23 13:29:38', 0, 500, 200, 1, b'0', NULL, NULL, 'public');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (10, '测试保存', 'http://1234', '1231232131232132323', '12123123213', b'0', b'0', b'0', b'0', '2023-04-04 15:35:25', '2023-04-04 15:35:25', 0, 19, 0, 2, b'1', NULL, NULL, 'protect');
INSERT INTO `blog` (`id`, `title`, `first_picture`, `content`, `description`, `is_published`, `is_recommend`, `is_appreciation`, `is_comment_enabled`, `create_time`, `update_time`, `views`, `words`, `read_time`, `category_id`, `is_top`, `password`, `user_id`, `visible_model`) VALUES (11, '测试保存2', 'hi u啊是对齐文华2', '# 就是个测试', '# 没啥可以写的', b'1', b'0', b'0', b'0', '2023-04-04 15:37:10', '2023-04-04 16:30:56', 0, 7, 0, 4, b'1', NULL, NULL, 'private');
COMMIT;

-- ----------------------------
-- Table structure for blog_tag
-- ----------------------------
DROP TABLE IF EXISTS `blog_tag`;
CREATE TABLE `blog_tag` (
  `blog_id` bigint NOT NULL COMMENT '博客ID',
  `tag_id` bigint NOT NULL COMMENT '标签ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of blog_tag
-- ----------------------------
BEGIN;
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (10, 7);
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (10, 5);
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (11, 7);
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (11, 4);
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (3, 4);
INSERT INTO `blog_tag` (`blog_id`, `tag_id`) VALUES (3, 5);
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章分类',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`id`, `category_name`) VALUES (1, '学习笔记');
INSERT INTO `category` (`id`, `category_name`) VALUES (2, '个人项目');
INSERT INTO `category` (`id`, `category_name`) VALUES (3, '技术杂烩');
INSERT INTO `category` (`id`, `category_name`) VALUES (4, '心情随写');
COMMIT;

-- ----------------------------
-- Table structure for city_visitor
-- ----------------------------
DROP TABLE IF EXISTS `city_visitor`;
CREATE TABLE `city_visitor` (
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '城市名称',
  `uv` int NOT NULL COMMENT '独立访客数量',
  PRIMARY KEY (`city`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of city_visitor
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论内容',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像(图片路径)',
  `create_time` datetime DEFAULT NULL COMMENT '评论创建时间',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论者ip地址',
  `is_published` bit(1) NOT NULL COMMENT '公开或回收站',
  `is_admin_comment` bit(1) NOT NULL COMMENT '博主回复',
  `page` int NOT NULL COMMENT '0普通文章，1关于我页面，2友链页面',
  `is_notice` bit(1) NOT NULL COMMENT '接收邮件提醒',
  `blog_id` bigint DEFAULT NULL COMMENT '所属的文章',
  `parent_comment_id` bigint NOT NULL COMMENT '父评论id，-1为根评论',
  `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '个人网站',
  `qq` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '如果评论昵称为QQ号，则将昵称和头像置为QQ昵称和QQ头像，并将此字段置为QQ号备份',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for exception_log
-- ----------------------------
DROP TABLE IF EXISTS `exception_log`;
CREATE TABLE `exception_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求接口',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
  `param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求参数',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作描述',
  `error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '异常信息',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip来源',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `create_time` datetime NOT NULL COMMENT '操作时间',
  `user_agent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'user-agent用户代理',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of exception_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for friend
-- ----------------------------
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend` (
  `id` bigint NOT NULL DEFAULT '0',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述',
  `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像',
  `is_published` bit(1) NOT NULL COMMENT '公开或隐藏',
  `views` int NOT NULL COMMENT '点击次数',
  `create_time` datetime NOT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of friend
-- ----------------------------
BEGIN;
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (1, '小陈1号23', '小陈1号的友链', 'http://localhost/8080/小陈1号', 'https://pic1.zhimg.com/80/v2-3f554cffb6cc0dc02f451214d5e711f4_1440w.webp', b'1', 0, '2023-03-18 18:57:36');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (2, '小陈2号', '小陈2号的友链', 'http://localhost/小陈2号', 'https://pic1.zhimg.com/80/v2-3f554cffb6cc0dc02f451214d5e711f4_1440w.webp', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (4, '小陈3号', '小陈3号的友链', 'http://localhost/小陈3号', 'https://xxs-photo.oss-cn-chengdu.aliyuncs.com/config/c37a3f87a1b6e1d21ebea9992c8d989e.png', b'1', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (5, '小陈4号', '小陈4号的友链', 'http://localhost/小陈4号', 'http://localhost/小陈4号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (6, '小陈5号', '小陈5号的友链', 'http://localhost/小陈5号', 'http://localhost/小陈5号/demo', b'1', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (8, '小陈7号', '小陈7号的友链', 'http://localhost/小陈7号', 'http://localhost/小陈7号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (9, '小陈8号', '小陈8号的友链', 'http://localhost/小陈8号', 'http://localhost/小陈8号/demo', b'1', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (10, '小陈9号', '小陈9号的友链', 'http://localhost/小陈9号', 'http://localhost/小陈9号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (11, '小陈10号', '小陈10号的友链', 'http://localhost/小陈10号', 'http://localhost/小陈10号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (12, '小陈11号', '小陈11号的友链', 'http://localhost/小陈11号', 'http://localhost/小陈11号/demo', b'1', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (13, '小陈12号', '小陈12号的友链', 'http://localhost/小陈12号', 'http://localhost/小陈12号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (14, '小陈13号', '小陈13号的友链', 'http://localhost/小陈13号', 'http://localhost/小陈13号/demo', b'1', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (15, '小陈14号', '小陈14号的友链', 'http://localhost/小陈14号', 'http://localhost/小陈14号/demo', b'0', 0, '2023-03-18 18:59:22');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (16, 'xiaochen124', 'xiaochen124', 'xiaochen124', 'xiaochen124', b'1', 0, '2023-03-18 19:35:25');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (17, '小徐1号', '小徐1号', 'http://128.160.24.123', '小徐1号', b'1', 0, '2023-03-18 22:49:55');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (18, '小泽2号', '小泽2号', '小泽2号', '小泽2号', b'0', 0, '2023-03-18 23:05:07');
INSERT INTO `friend` (`id`, `nickname`, `description`, `website`, `avatar`, `is_published`, `views`, `create_time`) VALUES (0, '小泽4号', '小泽4号', '小泽4号', '小泽4号', b'0', 0, '2023-03-18 23:12:32');
COMMIT;

-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名称',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip来源',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `status` bit(1) DEFAULT NULL COMMENT '登录状态',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作描述',
  `create_time` datetime NOT NULL COMMENT '登录时间',
  `user_agent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'user-agent用户代理',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of login_log
-- ----------------------------
BEGIN;
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (1, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-06 21:36:48', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (2, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-06 21:37:49', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (3, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-06 21:44:25', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (4, 'superAdmin', '192.168.10.32', '内网IP|内网IP', 'Unknown', 'UNKNOWN', b'1', '登陆', '2023-04-06 22:03:35', 'ApiPOST Runtime +https://www.apipost.cn');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (6, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-07 21:50:29', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (7, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-07 22:45:29', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (8, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-07 22:45:33', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (9, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 00:36:00', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (10, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 00:40:10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (11, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 00:41:16', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (12, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 00:41:23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (13, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 00:41:28', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (14, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 00:45:30', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (15, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 00:45:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (16, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 18:28:15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (17, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 18:33:15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (18, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 18:46:37', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (19, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 18:48:39', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (20, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 18:48:46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (21, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 18:49:01', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (22, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 18:51:24', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (23, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 18:52:32', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (24, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-08 18:52:39', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (25, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登出', '2023-04-08 18:56:01', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (26, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-10 22:52:47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `login_log` (`id`, `username`, `ip`, `ip_source`, `os`, `browser`, `status`, `description`, `create_time`, `user_agent`) VALUES (27, 'admin', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', b'1', '登陆', '2023-04-12 22:01:39', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
COMMIT;

-- ----------------------------
-- Table structure for moment
-- ----------------------------
DROP TABLE IF EXISTS `moment`;
CREATE TABLE `moment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '动态内容',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `likes` int DEFAULT NULL COMMENT '点赞数量',
  `is_published` bit(1) NOT NULL COMMENT '是否公开',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of moment
-- ----------------------------
BEGIN;
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (1, 'Hello Blog Hello BlogHello BlogHello BlogHello BlogHello BlogHello BlogHello BlogHello BlogHello Blog', '2023-03-24 11:37:09', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (2, 'Hello Blog1213412121212 -vys12', '2023-03-24 11:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (3, 'Hello Blog123', '2023-03-24 11:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (4, 'Hello Blog159', '2023-03-24 23:37:43', 10, b'0');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (5, 'Hello Blog 1231', '2023-03-24 23:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (6, 'Hello Bloghhh', '2023-03-24 23:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (7, '#Hello Blog', '2023-03-24 23:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (8, '##Hello Blog', '2023-03-24 23:37:43', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (10, '#HelloHello Blog', '2023-03-24 23:54:03', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (11, '##HelloHelloHelloHello Blog', '2023-03-24 23:54:03', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (12, '##HelloHelloHelloHello BloBlogBlogg', '2023-03-24 23:54:03', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (13, '##HelloHelHelloHelloHelloHelloloHelloHello Blog', '2023-03-24 23:54:03', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (14, 'Hello Blog', '2023-03-24 23:57:09', 10, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (15, 'Hello 12312asda -vys', '2023-03-24 11:37:43', 100, b'1');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (16, 'Hello TestLocalhost -vys', '2023-03-25 12:34:03', 100, b'0');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (17, '# hello world\n测试写动态', '2023-03-26 12:19:15', NULL, b'0');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (18, '## hello \n测试写动态', '2023-03-26 12:25:41', 0, b'0');
INSERT INTO `moment` (`id`, `content`, `create_time`, `likes`, `is_published`) VALUES (19, '12312312312321', '2023-03-26 12:46:31', 0, b'0');
COMMIT;

-- ----------------------------
-- Table structure for operation_log
-- ----------------------------
DROP TABLE IF EXISTS `operation_log`;
CREATE TABLE `operation_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作者用户名',
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求接口',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
  `param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求参数',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作描述',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip来源',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `times` int NOT NULL COMMENT '请求耗时（毫秒）',
  `create_time` datetime NOT NULL COMMENT '操作时间',
  `user_agent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'user-agent用户代理',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of operation_log
-- ----------------------------
BEGIN;
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (1, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 76, '2023-04-06 21:44:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (2, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 76, '2023-04-06 21:44:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (3, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 76, '2023-04-06 21:44:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (4, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 71, '2023-04-06 21:44:38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (5, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 130, '2023-04-06 21:44:38', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (6, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 90, '2023-04-06 21:56:01', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (7, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 127, '2023-04-06 21:56:01', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (8, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 28, '2023-04-06 22:01:12', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (9, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 63, '2023-04-06 22:01:12', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (10, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 74, '2023-04-06 22:01:33', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (11, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 33, '2023-04-06 22:01:33', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (12, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 89, '2023-04-06 22:07:46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (13, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 89, '2023-04-06 22:07:46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (14, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 89, '2023-04-06 22:07:46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (15, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-06 22:07:49', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (16, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 70, '2023-04-06 22:08:12', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (17, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 43, '2023-04-06 22:08:50', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (18, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 62, '2023-04-06 22:09:47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (19, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 31, '2023-04-06 22:09:52', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (20, 'admin', '/admin/about', 'GET', '{}', '关于我查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-06 22:10:02', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (21, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 20, '2023-04-06 22:10:08', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (22, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 35, '2023-04-06 22:10:08', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (23, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 39, '2023-04-06 22:10:08', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (24, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 76, '2023-04-06 22:10:11', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (25, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 128, '2023-04-06 22:10:12', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (26, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 29, '2023-04-06 22:10:13', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (27, 'admin', '/admin/getCategoryList', 'POST', '{\"categoryDTO\":{\"categoryName\":null,\"pageNo\":1,\"pageSize\":10}}', '查询分类列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 16, '2023-04-06 22:10:14', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (28, 'admin', '/admin/getTagList', 'POST', '{\"tagDTO\":{\"tagName\":null,\"pageNo\":1,\"pageSize\":10}}', '获取标签', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 56, '2023-04-06 22:10:15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (29, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 39, '2023-04-06 22:12:57', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (30, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 36, '2023-04-06 22:15:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (31, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 13, '2023-04-06 22:15:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (32, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 18, '2023-04-06 22:22:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (33, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 37, '2023-04-06 22:22:47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (34, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 35, '2023-04-06 22:22:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (35, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 35, '2023-04-06 22:23:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (36, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 25, '2023-04-06 22:24:43', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (37, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 14, '2023-04-06 22:24:51', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (38, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 36, '2023-04-06 22:24:54', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (39, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 42, '2023-04-06 22:27:23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (40, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 332, '2023-04-06 23:31:00', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (41, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 33, '2023-04-06 23:31:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (42, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 27, '2023-04-06 23:31:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (43, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 24, '2023-04-06 23:32:03', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (44, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 144, '2023-04-06 23:37:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (45, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 62, '2023-04-06 23:42:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (46, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 27, '2023-04-06 23:43:43', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (47, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 60, '2023-04-06 23:47:13', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (48, 'admin', '/admin/friends', 'POST', '{\"friendDTO\":{\"nickname\":null,\"pageNo\":1,\"pageSize\":10}}', '友链管理列表查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 34, '2023-04-06 23:47:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (49, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 82, '2023-04-06 23:48:15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (50, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 354, '2023-04-06 23:48:15', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (51, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-06 23:48:17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (52, 'admin', '/admin/getCategoryList', 'POST', '{\"categoryDTO\":{\"categoryName\":null,\"pageNo\":1,\"pageSize\":10}}', '查询分类列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 20, '2023-04-06 23:48:20', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (53, 'admin', '/admin/getTagList', 'POST', '{\"tagDTO\":{\"tagName\":null,\"pageNo\":1,\"pageSize\":10}}', '获取标签', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 60, '2023-04-06 23:48:23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (54, 'admin', '/admin/getTagList', 'POST', '{\"tagDTO\":{\"tagName\":null,\"pageNo\":1,\"pageSize\":10}}', '获取标签', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 296, '2023-04-06 23:51:18', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (55, 'admin', '/admin/getTagList', 'POST', '{\"tagDTO\":{\"tagName\":null,\"pageNo\":1,\"pageSize\":10}}', '获取标签', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 31, '2023-04-06 23:51:49', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (56, 'admin', '/admin/getTagList', 'POST', '{\"tagDTO\":{\"tagName\":null,\"pageNo\":1,\"pageSize\":10}}', '获取标签', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 28, '2023-04-06 23:52:10', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (57, 'admin', '/admin/getCategoryList', 'POST', '{\"categoryDTO\":{\"categoryName\":null,\"pageNo\":1,\"pageSize\":10}}', '查询分类列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 71, '2023-04-06 23:52:27', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (58, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 45, '2023-04-06 23:52:28', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (59, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 21, '2023-04-06 23:52:31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (60, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 100, '2023-04-06 23:52:31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (61, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 97, '2023-04-06 23:53:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (62, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 41, '2023-04-06 23:53:40', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (63, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 172, '2023-04-06 23:54:09', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (64, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 172, '2023-04-06 23:54:09', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (65, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 171, '2023-04-06 23:54:09', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (66, 'admin', '/admin/about', 'GET', '{}', '关于我查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 42, '2023-04-06 23:54:25', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (67, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 11, '2023-04-06 23:54:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (68, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 11, '2023-04-06 23:54:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (69, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 8, '2023-04-06 23:54:59', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (70, 'admin', '/admin/getTagDict', 'GET', '{}', '获取标签字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 16, '2023-04-06 23:55:29', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (71, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 18, '2023-04-06 23:55:29', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (72, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 27, '2023-04-06 23:55:32', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (73, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 59, '2023-04-06 23:55:32', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (74, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 50, '2023-04-06 23:55:33', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (75, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 7, '2023-04-06 23:55:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (76, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 21, '2023-04-06 23:55:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (77, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 27, '2023-04-06 23:56:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (78, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 51, '2023-04-06 23:56:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (79, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 49, '2023-04-06 23:56:55', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (80, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 21, '2023-04-06 23:56:55', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (81, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":5,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 21, '2023-04-06 23:56:58', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (82, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 60, '2023-04-06 23:57:00', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (83, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":5,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 49, '2023-04-06 23:57:00', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (84, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":5,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 12, '2023-04-06 23:57:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (85, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 87, '2023-04-06 23:58:31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (86, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 55, '2023-04-06 23:58:31', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (87, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 33, '2023-04-06 23:58:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (88, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 22, '2023-04-06 23:58:39', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (89, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 12, '2023-04-06 23:58:41', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (90, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":2,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 62, '2023-04-06 23:58:42', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (91, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 40, '2023-04-06 23:58:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (92, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":2,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 25, '2023-04-06 23:59:57', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (93, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":5}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 30, '2023-04-06 23:59:58', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (94, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 18, '2023-04-07 00:00:00', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (95, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 61, '2023-04-07 00:00:04', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (96, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":2,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 24, '2023-04-07 00:00:07', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (97, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":3,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 13, '2023-04-07 00:00:07', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (98, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":3,\"pageSize\":5}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 13, '2023-04-07 00:00:09', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (99, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":3,\"pageSize\":100}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 7, '2023-04-07 00:00:11', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (100, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":3,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 44, '2023-04-07 00:00:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (101, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 46, '2023-04-07 00:00:35', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (102, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":100}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 38, '2023-04-07 00:00:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (103, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 24, '2023-04-07 00:00:55', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (104, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 12, '2023-04-07 00:01:06', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (105, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":200}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 34, '2023-04-07 00:01:09', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (106, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 37, '2023-04-07 00:01:18', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (107, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":9,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 14, '2023-04-07 00:01:23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (108, 'admin', '/admin/about', 'GET', '{}', '关于我查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 47, '2023-04-07 22:45:41', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (109, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-07 22:45:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (110, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-07 22:45:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (111, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 57, '2023-04-07 22:45:44', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (112, 'admin', '/admin/about', 'GET', '{}', '关于我查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 18, '2023-04-07 22:45:53', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (113, 'admin', '/admin/siteSetting', 'GET', '{\"type\":3}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 27, '2023-04-07 22:46:11', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (114, 'admin', '/admin/siteSetting', 'GET', '{\"type\":1}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 17, '2023-04-07 22:46:11', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (115, 'admin', '/admin/siteSetting', 'GET', '{\"type\":2}', '站点设置查询', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 30, '2023-04-07 22:46:11', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (116, 'admin', '/admin/getOperationLogList', 'POST', '{\"logDTO\":{\"beginTime\":null,\"endTime\":null,\"pageNo\":1,\"pageSize\":10}}', '获取日志列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 172, '2023-04-08 00:46:23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (117, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 70, '2023-04-10 22:52:54', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (118, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 347, '2023-04-10 22:52:55', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (119, 'admin', '/admin/getCategoryList', 'POST', '{\"categoryDTO\":{\"categoryName\":null,\"pageNo\":1,\"pageSize\":10}}', '查询分类列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 143, '2023-04-10 23:03:34', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (120, 'admin', '/admin/getMomentList', 'POST', '{\"momentDTO\":{\"id\":null,\"content\":null,\"createTime\":null,\"likes\":null,\"isPublished\":null,\"pageNo\":1,\"pageSize\":10}}', '获取动态列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 90, '2023-04-10 23:03:46', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (121, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 16, '2023-04-10 23:03:47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (122, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 138, '2023-04-10 23:03:47', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (123, 'admin', '/admin/getCateGoryDict', 'GET', '{}', '查询分类字典', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 76, '2023-04-12 22:01:45', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
INSERT INTO `operation_log` (`id`, `username`, `uri`, `method`, `param`, `description`, `ip`, `ip_source`, `os`, `browser`, `times`, `create_time`, `user_agent`) VALUES (124, 'admin', '/admin/getBlogList', 'POST', '{\"blogListDTO\":{\"id\":null,\"title\":null,\"categoryId\":null,\"pageNo\":1,\"pageSize\":10}}', '获取博客列表', '192.168.10.32', '内网IP|内网IP', 'Mac OS X', 'CHROME10', 171, '2023-04-12 22:01:45', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法名',
  `params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数',
  `cron` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint DEFAULT NULL COMMENT '任务状态',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron`, `status`, `remark`, `create_time`) VALUES (1, 'redisSyncScheduleTask', 'syncBlogViewsToDatabase', '', '0 0 1 * * ?', 1, '每天凌晨一点，从Redis将博客浏览量同步到数据库', '2020-11-17 23:45:42');
INSERT INTO `schedule_job` (`job_id`, `bean_name`, `method_name`, `params`, `cron`, `status`, `remark`, `create_time`) VALUES (2, 'visitorSyncScheduleTask', 'syncVisitInfoToDatabase', '', '0 0 0 * * ?', 1, '清空当天Redis访客标识，记录当天的PV和UV，更新当天所有访客的PV和最后访问时间，更新城市新增访客UV数', '2021-02-05 08:14:28');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint NOT NULL COMMENT '任务id',
  `bean_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法名',
  `params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '参数',
  `status` tinyint NOT NULL COMMENT '任务执行结果',
  `error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '异常信息',
  `times` int NOT NULL COMMENT '耗时（单位：毫秒）',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for site_setting
-- ----------------------------
DROP TABLE IF EXISTS `site_setting`;
CREATE TABLE `site_setting` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_zh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `type` int DEFAULT NULL COMMENT '1基础设置，2页脚徽标，3资料卡，4友链信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of site_setting
-- ----------------------------
BEGIN;
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (1, 'blogName', '博客名称', 'Hello Blog123', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (2, 'webTitleSuffix', '网页标题后缀', ' - Hello Blog', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (3, 'footerImgTitle', '页脚图片标题', '随便写一点', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (4, 'footerImgUrl', '页脚图片路径', '/img/qr.png', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (5, 'copyright', 'Copyright', '{\"title\":\"Copyright © 2019 - 2022\",\"siteName\":\"NACCL\'S BLOG\"}', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (6, 'beian', 'ICP备案号', '16548745415', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (7, 'reward', '赞赏码', '/img/reward.jpg', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (8, 'commentAdminFlag', '博主评论标识', '生鸽', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (9, 'playlistServer', '播放器平台', '网抑云', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (10, 'playlistId', '播放器歌单', '4498489979', 1);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (11, 'avatar', '头像', '/img/avatar.jpg', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (12, 'name', '昵称', 'chentongsheng', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (13, 'rollText', '滚动个签', '\"云鹤当归天，天不迎我妙木仙；\",\"游龙当归海，海不迎我自来也。\"', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (14, 'github', 'GitHub', 'https://gitee.com/start_work_tomorrow/vue-naive-admin', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (15, 'telegram', 'Telegram', 'https://t.me/NacclOfficial', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (16, 'qq', 'QQ', 'http://sighttp.qq.com/authd?IDKEY=', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (17, 'bilibili', 'bilibili', 'https://space.bilibili.com/', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (18, 'netease', '网易云音乐', 'https://music.163.com/#/user/home?id=', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (19, 'email', 'email', 'mailto:you@example.com', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (20, 'favorite', '自定义', '{\"title\":\"最喜欢的动漫 📺\",\"content\":\"异度侵入、春物语、NO GAME NO LIFE、实力至上主义的教室、辉夜大小姐、青春猪头少年不会梦到兔女郎学姐、路人女主、Re0、魔禁、超炮、俺妹、在下坂本、散华礼弥、OVERLORD、慎勇、人渣的本愿、白色相簿2、死亡笔记、DARLING in the FRANXX、鬼灭之刃\"}', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (21, 'favorite', '自定义', '{\"title\":\"最喜欢我的女孩子们 🤤\",\"content\":\"芙兰达、土间埋、食蜂操祈、佐天泪爷、樱岛麻衣、桐崎千棘、02、亚丝娜、高坂桐乃、五更琉璃、安乐冈花火、一色彩羽、英梨梨、珈百璃、时崎狂三、可儿那由多、和泉纱雾、早坂爱\"}', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (22, 'favorite', '自定义', '{\"title\":\"最喜欢玩的游戏 🎮\",\"content\":\"Stellaris、巫师、GTA、荒野大镖客、刺客信条、魔兽争霸、LOL、PUBG\"}', 2);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (23, 'badge', '徽标', '{\"title\":\"本博客已开源于 GitHub\",\"url\":\"https://github.com/Naccl/NBlog\",\"subject\":\"NBlog\",\"value\":\"Open Source\",\"color\":\"brightgreen\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (24, 'badge', '徽标', '{\"title\":\"由 Spring Boot 强力驱动\",\"url\":\"https://spring.io/projects/spring-boot/\",\"subject\":\"Powered\",\"value\":\"Spring Boot\",\"color\":\"blue\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (25, 'badge', '徽标', '{\"title\":\"Vue.js 客户端渲染\",\"url\":\"https://cn.vuejs.org/\",\"subject\":\"SPA\",\"value\":\"Vue.js\",\"color\":\"brightgreen\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (26, 'badge', '徽标', '{\"title\":\"UI 框架 Semantic-UI\",\"url\":\"https://semantic-ui.com/\",\"subject\":\"UI\",\"value\":\"Semantic-UI\",\"color\":\"semantic-ui\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (27, 'badge', '徽标', '{\"title\":\"阿里云提供服务器及域名相关服务\",\"url\":\"https://www.aliyun.com/\",\"subject\":\"VPS & DNS\",\"value\":\"Aliyun\",\"color\":\"blueviolet\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (28, 'badge', '徽标', '{\"title\":\"静态资源托管于 GitHub\",\"url\":\"https://github.com/\",\"subject\":\"OSS\",\"value\":\"GitHub\",\"color\":\"github\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (29, 'badge', '徽标', '{\"title\":\"jsDelivr 加速静态资源\",\"url\":\"https://www.jsdelivr.com/\",\"subject\":\"CDN\",\"value\":\"jsDelivr\",\"color\":\"orange\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (30, 'badge', '徽标', '{\"color\":\"lightgray\",\"subject\":\"CC\",\"title\":\"本站点采用 CC BY 4.0 国际许可协议进行许可\",\"url\":\"https://creativecommons.org/licenses/by/4.0/\",\"value\":\"BY 4.0\"}', 3);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (31, 'friendContent', '友链页面信息', '随机排序，不分先后。欢迎交换友链~(￣▽￣)~*\n\n* 昵称：Naccl\n* 一句话：游龙当归海，海不迎我自来也。\n* 网址：[https://naccl.top](https://naccl.top)\n* 头像URL：[https://naccl.top/img/avatar.jpg](https://naccl.top/img/avatar.jpg)\n\n仅凭个人喜好添加友链，请在收到我的回复邮件后再于贵站添加本站链接。原则上已添加的友链不会删除，如果你发现自己被移除了，恕不另行通知，只需和我一样做就好。\n\n', 4);
INSERT INTO `site_setting` (`id`, `name_en`, `name_zh`, `value`, `type`) VALUES (32, 'friendCommentEnabled', '友链页面评论开关', '1', 4);
COMMIT;

-- ----------------------------
-- Table structure for tag
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签名称',
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标签颜色(可选)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of tag
-- ----------------------------
BEGIN;
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (1, '测试标签1', 'violet');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (3, '标签测试2', 'olive');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (4, '标签测试3', 'red');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (5, '标签测试4', 'yellow');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (6, '标签测试21', 'teal');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (7, '标签测试6', 'brown');
INSERT INTO `tag` (`id`, `tag_name`, `color`) VALUES (9, 'render测试', 'grey');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像地址',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色访问权限',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `password`, `nickname`, `avatar`, `email`, `create_time`, `update_time`, `role`) VALUES (1, 'admin', '$2a$10$QCqGOXYpfHcyGaxcdfOcBuolbQsXuZnDSQjFl04d6S5M4xuqiH4AW', 'Admin12', '/img/avatar.jpg', 'admin@naccl.top', '2020-09-21 16:47:18', '2020-09-21 16:47:22', 'admin');
INSERT INTO `user` (`id`, `username`, `password`, `nickname`, `avatar`, `email`, `create_time`, `update_time`, `role`) VALUES (2, 'superAdmin', '$2a$10$6JCE0BRkLVTb4nmUfQUyZOJgqlLQyIEDV/YAlLoe877mkNeN2c5Hm', 'superAdmin', '/img/avatar.jpg', 'admin@naccl.top', '2020-09-21 16:47:18', '2020-09-21 16:47:22', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for visit_log
-- ----------------------------
DROP TABLE IF EXISTS `visit_log`;
CREATE TABLE `visit_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '访客标识码',
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求接口',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
  `param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求参数',
  `behavior` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '访问行为',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '访问内容',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip来源',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `times` int NOT NULL COMMENT '请求耗时（毫秒）',
  `create_time` datetime NOT NULL COMMENT '访问时间',
  `user_agent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'user-agent用户代理',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of visit_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for visit_record
-- ----------------------------
DROP TABLE IF EXISTS `visit_record`;
CREATE TABLE `visit_record` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `pv` int NOT NULL COMMENT '访问量',
  `uv` int NOT NULL COMMENT '独立用户',
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日期"02-23"',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of visit_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for visitor
-- ----------------------------
DROP TABLE IF EXISTS `visitor`;
CREATE TABLE `visitor` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访客标识码',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip',
  `ip_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ip来源',
  `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '浏览器',
  `create_time` datetime NOT NULL COMMENT '首次访问时间',
  `last_time` datetime NOT NULL COMMENT '最后访问时间',
  `pv` int DEFAULT NULL COMMENT '访问页数统计',
  `user_agent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'user-agent用户代理',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_uuid` (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of visitor
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
